Overview

Dataset info

Number of variables38
Number of observations154117
Missing cells849987 (14.5%)
Duplicate rows0 (0.0%)
Total size in memory43.7 MiB
Average record size in memory297.0 B

Variables types

Numeric8
Categorical25
Boolean2
Date0
URL0
Text (Unique)1
Rejected2
Unsupported0

Warnings

AdditionSQFT is highly skewed (γ1 = 27.99978385) Skewed
AdditionSQFT has 140060 (90.9%) zeros Zeros
AdditionSQFT has 3197 (2.1%) missing values Missing
ApplicationNumber has a high cardinality: 77932 distinct values Warning
BuildingFinalLastInspDate has a high cardinality: 31514 distinct values Warning
BuildingFinalLastInspDate has 119957 (77.8%) missing values Missing
BuildingFinalLastInspResult has 154116 (> 99.9%) missing values Missing
Certificatecode has 140926 (91.4%) missing values Missing
Certificatedate has a high cardinality: 10522 distinct values Warning
Certificatedate has 140926 (91.4%) missing values Missing
CompanyAddress has a high cardinality: 9695 distinct values Warning
CompanyAddress has 6227 (4.0%) missing values Missing
CompanyCity has a high cardinality: 849 distinct values Warning
CompanyCity has 6227 (4.0%) missing values Missing
CompanyName has a high cardinality: 9754 distinct values Warning
CompanyName has 6227 (4.0%) missing values Missing
CompanyZip has 6227 (4.0%) missing values Missing
DaysInCity has a high cardinality: 32136 distinct values Warning
DaysInCity has 5031 (3.3%) missing values Missing
DaysInCityNumeric has 81058 (52.6%) zeros Zeros
DaysInCityNumeric has 5031 (3.3%) missing values Missing
DeliveryAddress has a high cardinality: 41535 distinct values Warning
FirstSubmissionDate has a high cardinality: 94606 distinct values Warning
FirstSubmissionDate has 4981 (3.2%) missing values Missing
IssuedDate has a high cardinality: 127696 distinct values Warning
Location_1 has a high cardinality: 31970 distinct values Warning
Miami21Zone has a high cardinality: 157 distinct values Warning
NewAdditionCost is highly skewed (γ1 = 43.34014033) Skewed
NewAdditionCost has 57046 (37.0%) zeros Zeros
NewAdditionCost has 90440 (58.7%) missing values Missing
PlanAcceptedDate has a high cardinality: 98179 distinct values Warning
PlanCreatedDate only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
PlanCreatedDate has a high cardinality: 102994 distinct values Warning
ProcessNumber has a high cardinality: 109652 distinct values Warning
RemodelingCost is highly skewed (γ1 = 50.87572019) Skewed
RemodelingCost has 53872 (35.0%) zeros Zeros
RemodelingCost has 70585 (45.8%) missing values Missing
RemSQFT is highly skewed (γ1 = 62.82331835) Skewed
RemSQFT has 122019 (79.2%) zeros Zeros
RemSQFT has 3197 (2.1%) missing values Missing
RequiredCertificate has 79079 (51.3%) missing values Missing
Statusdate only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
Statusdate has a high cardinality: 118181 distinct values Warning
TotalCost is highly correlated with NewAdditionCost (ρ = 0.9322690698) Rejected
TotalDaysInPlanReview has a high cardinality: 74681 distinct values Warning
TotalDaysInPlanReviewNumeric has 37133 (24.1%) zeros Zeros
TotalSQFT is highly correlated with AdditionSQFT (ρ = 0.9908311729) Rejected
WorkItems has a high cardinality: 14730 distinct values Warning

Variables

AdditionSQFT
Numeric

Distinct count1558
Unique (%)1.0%
Missing (%)2.1%
Missing (n)3197
Infinite (%)0.0%
Infinite (n)0
Mean2754.821342
Minimum0
Maximum2450323
Zeros (%)90.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile775
Maximum2450323
Range2450323
Interquartile range0

Descriptive statistics

Standard deviation44500.89122
Coef of variation16.15382113
Kurtosis1010.10109
Mean2754.821342
MAD5258.444164
Skewness27.99978385
Sum415757637
Variance1980329319
Memory size1.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 140060 90.9%
 
200 163 0.1%
 
4000 150 0.1%
 
300 124 0.1%
 
5000 111 0.1%
 
100 92 0.1%
 
1500 85 0.1%
 
2500 84 0.1%
 
500 82 0.1%
 
400 82 0.1%
 
Other values (1547) 9887 6.4%
 
(Missing) 3197 2.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 140060 90.9%
 
1 77 < 0.1%
 
2 8 < 0.1%
 
4 1 < 0.1%
 
10 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2450323 6 < 0.1%
 
1904889 6 < 0.1%
 
1844181 6 < 0.1%
 
1788667 6 < 0.1%
 
1575474 6 < 0.1%
 

ApplicationNumber
Categorical

Distinct count77932
Unique (%)50.6%
Missing (%)0.0%
Missing (n)0
BD15007674
 
117
BD14014244
 
116
BD13024837
 
114
Other values (77929)
153770
ValueCountFrequency (%) 
BD15007674 117 0.1%
 
BD14014244 116 0.1%
 
BD13024837 114 0.1%
 
BD14013442 112 0.1%
 
BD12010756 103 0.1%
 
BD14014407 98 0.1%
 
BD14011309 98 0.1%
 
BD13021838 95 0.1%
 
BD14009787 94 0.1%
 
BD15002212 91 0.1%
 
Other values (77922) 153079 99.3%
 
Max length10
Mean length10
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

BuildingFinalLastInspDate
Categorical

Distinct count31514
Unique (%)20.4%
Missing (%)77.8%
Missing (n)119957
07/02/2015 09:00:00 AM
 
7
09/28/2018 09:59:00 AM
 
6
03/10/2016 03:18:00 PM
 
6
Other values (31510)
34141
(Missing)
119957
ValueCountFrequency (%) 
07/02/2015 09:00:00 AM 7 < 0.1%
 
09/28/2018 09:59:00 AM 6 < 0.1%
 
03/10/2016 03:18:00 PM 6 < 0.1%
 
06/04/2018 02:59:00 PM 6 < 0.1%
 
05/23/2014 12:26:00 PM 6 < 0.1%
 
01/26/2017 08:23:00 AM 6 < 0.1%
 
06/01/2015 10:26:00 AM 5 < 0.1%
 
04/22/2015 02:34:00 PM 5 < 0.1%
 
06/04/2018 03:00:00 PM 5 < 0.1%
 
06/26/2013 03:32:00 PM 5 < 0.1%
 
Other values (31503) 34103 22.1%
 
(Missing) 119957 77.8%
 
Max length22
Mean length7.211345925
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

BuildingFinalLastInspResult
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)154116
OK
 
1
(Missing)
154116
ValueCountFrequency (%) 
OK 1 < 0.1%
 
(Missing) 154116 > 99.9%
 
Max length3
Mean length2.999993511
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

BuildingPermitStatusDescription
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Final
133189
Active
 
11167
Revoked
 
5045
Other values (2)
 
4716
ValueCountFrequency (%) 
Final 133189 86.4%
 
Active 11167 7.2%
 
Revoked 5045 3.3%
 
Expired 4372 2.8%
 
Hold 344 0.2%
 
Max length7
Mean length5.192431724
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

BuildingPermitStatusReasonDescription
Categorical

Distinct count13
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
All Inspections are finalized.
133189
Permit is Active. Ready for Inspections.
 
11166
Revoked
 
5045
Other values (10)
 
4717
ValueCountFrequency (%) 
All Inspections are finalized. 133189 86.4%
 
Permit is Active. Ready for Inspections. 11166 7.2%
 
Revoked 5045 3.3%
 
Permit is Expired 4372 2.8%
 
Building Official 214 0.1%
 
Expired TCC/TCO 46 < 0.1%
 
Hold with Stop Work Order 29 < 0.1%
 
NSF Check 17 < 0.1%
 
Litigation 11 < 0.1%
 
Insufficient Fee Collection 11 < 0.1%
 
Other values (3) 17 < 0.1%
 
Max length40
Mean length29.57420012
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Certificatecode
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)91.4%
Missing (n)140926
CC
 
8087
C40
 
3191
CO
 
1754
Other values (2)
 
159
(Missing)
140926
ValueCountFrequency (%) 
CC 8087 5.2%
 
C40 3191 2.1%
 
CO 1754 1.1%
 
TCC 103 0.1%
 
TCO 56 < 0.1%
 
(Missing) 140926 91.4%
 
Max length3
Mean length2.936145915
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Certificatedate
Categorical

Distinct count10522
Unique (%)6.8%
Missing (%)91.4%
Missing (n)140926
08/24/2016 02:00:00 AM
 
76
08/29/2016 02:00:00 AM
 
63
11/08/2016 02:00:00 AM
 
54
Other values (10518)
 
12998
(Missing)
140926
ValueCountFrequency (%) 
08/24/2016 02:00:00 AM 76 < 0.1%
 
08/29/2016 02:00:00 AM 63 < 0.1%
 
11/08/2016 02:00:00 AM 54 < 0.1%
 
06/25/2017 02:00:00 AM 53 < 0.1%
 
08/31/2016 02:00:00 AM 51 < 0.1%
 
05/18/2018 02:00:00 AM 36 < 0.1%
 
09/17/2016 02:00:00 AM 27 < 0.1%
 
06/20/2018 02:01:00 AM 26 < 0.1%
 
05/17/2018 02:01:00 AM 26 < 0.1%
 
09/20/2016 02:00:00 AM 23 < 0.1%
 
Other values (10511) 12756 8.3%
 
(Missing) 140926 91.4%
 
Max length22
Mean length4.62622553
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

CompanyAddress
Categorical

Distinct count9695
Unique (%)6.3%
Missing (%)4.0%
Missing (n)6227
104 Crandon Blvd #308
 
955
2122 NW 7 AV
 
847
11600 DR ML KING JR ST. N.
 
739
Other values (9691)
145349
(Missing)
 
6227
ValueCountFrequency (%) 
104 Crandon Blvd #308 955 0.6%
 
2122 NW 7 AV 847 0.5%
 
11600 DR ML KING JR ST. N. 739 0.5%
 
8319 NW 43 rd Street 664 0.4%
 
10125 NW 116 Way 654 0.4%
 
2455 PACES FERRY ROAD BUILDING C-20 637 0.4%
 
14008 NW 82 AV 608 0.4%
 
7481 NW 66 ST 588 0.4%
 
7451 nw 63 st 549 0.4%
 
10785 MARKS WAY 526 0.3%
 
Other values (9684) 141123 91.6%
 
(Missing) 6227 4.0%
 
Max length80
Mean length16.8546429
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

CompanyCity
Categorical

Distinct count849
Unique (%)0.6%
Missing (%)4.0%
Missing (n)6227
MIAMI
48763
Miami
31383
HIALEAH
 
5709
Other values (845)
62035
(Missing)
 
6227
ValueCountFrequency (%) 
MIAMI 48763 31.6%
 
Miami 31383 20.4%
 
HIALEAH 5709 3.7%
 
Hialeah 4601 3.0%
 
HOLLYWOOD 1837 1.2%
 
DORAL 1833 1.2%
 
POMPANO BEACH 1542 1.0%
 
Ft. Lauderdale 1340 0.9%
 
MIAMI LAKES 1295 0.8%
 
Hollywood 1249 0.8%
 
Other values (838) 48338 31.4%
 
(Missing) 6227 4.0%
 
Max length21
Mean length6.957110507
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

CompanyName
Categorical

Distinct count9754
Unique (%)6.3%
Missing (%)4.0%
Missing (n)6227
Mar B Plumbing Corp.
 
955
FRIENDLY JOHN INC
 
847
POWER DESIGN INC
 
739
Other values (9750)
145349
(Missing)
 
6227
ValueCountFrequency (%) 
Mar B Plumbing Corp. 955 0.6%
 
FRIENDLY JOHN INC 847 0.5%
 
POWER DESIGN INC 739 0.5%
 
MARINI PLUMBING INC 664 0.4%
 
Fisk Electric Company 654 0.4%
 
Home Depot AtHome Services (the) 637 0.4%
 
TROPICAL FIRE & SECURITY SYSTEMS INC 597 0.4%
 
THYSSENKRUPP ELEVATOR CORP MIAMI 588 0.4%
 
United Site Services of Florida Inc. 549 0.4%
 
OTIS ELEVATOR COMPANY 526 0.3%
 
Other values (9743) 141134 91.6%
 
(Missing) 6227 4.0%
 
Max length85
Mean length25.47123289
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

CompanyZip
Numeric

Distinct count830
Unique (%)0.5%
Missing (%)4.0%
Missing (n)6227
Infinite (%)0.0%
Infinite (n)0
Mean33154.69175
Minimum0
Maximum98466
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile33012
Q133073
Median33155
Q333178
95-th percentile33442
Maximum98466
Range98466
Interquartile range105

Descriptive statistics

Standard deviation3315.473555
Coef of variation0.1000001321
Kurtosis147.5797001
Mean33154.69175
MAD440.0561458
Skewness2.846926246
Sum4903247363
Variance10992364.9
Memory size1.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
33166 6376 4.1%
 
33155 5703 3.7%
 
33186 4562 3.0%
 
33165 3995 2.6%
 
33142 3520 2.3%
 
33144 3245 2.1%
 
33016 3230 2.1%
 
33126 2923 1.9%
 
33012 2874 1.9%
 
33014 2655 1.7%
 
Other values (819) 108807 70.6%
 
(Missing) 6227 4.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 533 0.3%
 
1970 1 < 0.1%
 
2115 2 < 0.1%
 
2118 68 < 0.1%
 
3042 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
98466 2 < 0.1%
 
98106 1 < 0.1%
 
98045 1 < 0.1%
 
95438 2 < 0.1%
 
95008 1 < 0.1%
 

DaysInCity
Categorical

Distinct count32136
Unique (%)20.9%
Missing (%)3.3%
Missing (n)5031
0 Day(s) 0 Hour(s) 1 Minute(s)
 
2412
0 Day(s) 0 Hour(s) 2 Minute(s)
 
1385
0 Day(s) 0 Hour(s) 3 Minute(s)
 
1058
Other values (32132)
144231
(Missing)
 
5031
ValueCountFrequency (%) 
0 Day(s) 0 Hour(s) 1 Minute(s) 2412 1.6%
 
0 Day(s) 0 Hour(s) 2 Minute(s) 1385 0.9%
 
0 Day(s) 0 Hour(s) 3 Minute(s) 1058 0.7%
 
0 Day(s) 0 Hour(s) 0 Minute(s) 1001 0.6%
 
0 Day(s) 0 Hour(s) 4 Minute(s) 933 0.6%
 
0 Day(s) 0 Hour(s) 5 Minute(s) 773 0.5%
 
0 Day(s) 0 Hour(s) 6 Minute(s) 721 0.5%
 
0 Day(s) 0 Hour(s) 7 Minute(s) 685 0.4%
 
0 Day(s) 0 Hour(s) 10 Minute(s) 599 0.4%
 
0 Day(s) 0 Hour(s) 8 Minute(s) 598 0.4%
 
Other values (32125) 138921 90.1%
 
(Missing) 5031 3.3%
 
Max length35
Mean length30.52480907
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

DaysInCityNumeric
Numeric

Distinct count947
Unique (%)0.6%
Missing (%)3.3%
Missing (n)5031
Infinite (%)0.0%
Infinite (n)0
Mean34.37273118
Minimum0
Maximum3148
Zeros (%)52.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q318
95-th percentile183
Maximum3148
Range3148
Interquartile range18

Descriptive statistics

Standard deviation110.1943011
Coef of variation3.205863989
Kurtosis103.7017723
Mean34.37273118
MAD49.95426548
Skewness7.955846467
Sum5124493
Variance12142.78399
Memory size1.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 81058 52.6%
 
1 4866 3.2%
 
3 2512 1.6%
 
2 2470 1.6%
 
6 2220 1.4%
 
5 2146 1.4%
 
4 2048 1.3%
 
7 2013 1.3%
 
8 1684 1.1%
 
13 1504 1.0%
 
Other values (936) 46565 30.2%
 
(Missing) 5031 3.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 81058 52.6%
 
1 4866 3.2%
 
2 2470 1.6%
 
3 2512 1.6%
 
4 2048 1.3%
 

Maximum 5 values

ValueCountFrequency (%) 
3148 7 < 0.1%
 
2843 1 < 0.1%
 
2406 1 < 0.1%
 
2359 2 < 0.1%
 
2282 3 < 0.1%
 

DeliveryAddress
Categorical

Distinct count41535
Unique (%)27.0%
Missing (%)0.0%
Missing (n)0
701 S MIAMI AV
 
745
1611 NW 12 AV
 
719
180 SE 32 RD
 
413
Other values (41532)
152240
ValueCountFrequency (%) 
701 S MIAMI AV 745 0.5%
 
1611 NW 12 AV 719 0.5%
 
180 SE 32 RD 413 0.3%
 
1400 NW 12 AV 333 0.2%
 
1475 NW 12 AV 304 0.2%
 
301 BISCAYNE BLVD 278 0.2%
 
460 NE 28 ST 273 0.2%
 
200 S BISCAYNE BLVD 262 0.2%
 
600 BRICKELL AV 254 0.2%
 
3663 S MIAMI AV 200 0.1%
 
Other values (41525) 150336 97.5%
 
Max length37
Mean length15.23539908
Min length9
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

FirstSubmissionDate
Categorical

Distinct count94606
Unique (%)61.4%
Missing (%)3.2%
Missing (n)4981
03/17/2014 10:21:00 AM
 
12
03/03/2016 10:00:00 AM
 
12
10/29/2015 09:54:00 AM
 
11
Other values (94602)
149101
(Missing)
 
4981
ValueCountFrequency (%) 
03/17/2014 10:21:00 AM 12 < 0.1%
 
03/03/2016 10:00:00 AM 12 < 0.1%
 
10/29/2015 09:54:00 AM 11 < 0.1%
 
05/02/2013 07:53:00 AM 11 < 0.1%
 
11/13/2014 09:21:00 AM 10 < 0.1%
 
08/19/2013 09:55:00 AM 10 < 0.1%
 
06/03/2013 08:36:00 AM 10 < 0.1%
 
03/08/2017 10:01:00 AM 10 < 0.1%
 
07/24/2017 09:31:00 AM 10 < 0.1%
 
04/19/2017 07:58:00 AM 10 < 0.1%
 
Other values (94595) 149030 96.7%
 
(Missing) 4981 3.2%
 
Max length22
Mean length21.38592757
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

FolioNumber
Numeric

Distinct count37721
Unique (%)24.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.332130916e+11
Minimum1.01e+11
Maximum1.47170009e+11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.01e+11
5-th percentile1.020006012e+11
Q11.312507700e+11
Median1.32310681e+11
Q31.412100115e+11
95-th percentile1.413908429e+11
Maximum1.47170009e+11
Range4.617000897e+10
Interquartile range9959241410

Descriptive statistics

Standard deviation1.168528199e+10
Coef of variation0.08771872075
Kurtosis2.670836963
Mean1.332130916e+11
MAD7867428721
Skewness-1.892854327
Sum2.053040205e+16
Variance1.365458151e+20
Memory size1.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.01000000e+11 1.01000000e+11 1.01000001e+11 1.01000001e+11 1.01000001e+11 ... 1.42170000e+11 1.42170000e+11 1.42175000e+11 1.44690005e+11 1.47170009e+11], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1.021006011e+11 1238 0.8%
 
1.3135003e+11 811 0.5%
 
1.011403014e+11 715 0.5%
 
1.021003013e+11 588 0.4%
 
1.4138034e+11 559 0.4%
 
1.021003010e+11 555 0.4%
 
1.020503021e+11 520 0.3%
 
1.01120001e+11 501 0.3%
 
1.011403011e+11 501 0.3%
 
1.4139035e+11 490 0.3%
 
Other values (37711) 147639 95.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1.01e+11 1 < 0.1%
 
1.01e+11 1 < 0.1%
 
1.010000001e+11 2 < 0.1%
 
1.010000003e+11 7 < 0.1%
 
1.010000005e+11 278 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
1.47170009e+11 413 0.3%
 
1.4221e+11 142 0.1%
 
1.4218e+11 1 < 0.1%
 
1.4218e+11 1 < 0.1%
 
1.421700001e+11 117 0.1%
 

IsPermitFinal
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
YES
133189
NO
 
20928
ValueCountFrequency (%) 
YES 133189 86.4%
 
NO 20928 13.6%
 

IsPrivateProvider
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
140717
True
 
13400
ValueCountFrequency (%) 
False 140717 91.3%
 
True 13400 8.7%
 

IssuedDate
Categorical

Distinct count127696
Unique (%)82.9%
Missing (%)< 0.1%
Missing (n)52
08/24/2016 02:00:00 AM
 
76
08/29/2016 02:00:00 AM
 
63
11/08/2016 02:00:00 AM
 
54
Other values (127692)
153872
ValueCountFrequency (%) 
08/24/2016 02:00:00 AM 76 < 0.1%
 
08/29/2016 02:00:00 AM 63 < 0.1%
 
11/08/2016 02:00:00 AM 54 < 0.1%
 
06/25/2017 02:00:00 AM 53 < 0.1%
 
08/31/2016 02:00:00 AM 51 < 0.1%
 
06/23/2017 03:41:00 PM 42 < 0.1%
 
05/18/2018 02:00:00 AM 36 < 0.1%
 
11/08/2017 04:47:00 PM 29 < 0.1%
 
09/17/2016 02:00:00 AM 27 < 0.1%
 
06/20/2018 02:01:00 AM 26 < 0.1%
 
Other values (127685) 153608 99.7%
 
(Missing) 52 < 0.1%
 
Max length22
Mean length21.99358929
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Location_1
Categorical

Distinct count31970
Unique (%)20.7%
Missing (%)0.0%
Missing (n)0
(25.7672237928512, -80.1932309447959)
 
684
(25.7679434530999, -80.1971213733675)
 
626
(25.7906094667165, -80.2148913125127)
 
602
Other values (31967)
152205
ValueCountFrequency (%) 
(25.7672237928512, -80.1932309447959) 684 0.4%
 
(25.7679434530999, -80.1971213733675) 626 0.4%
 
(25.7906094667165, -80.2148913125127) 602 0.4%
 
(25.8049678684154, -80.1861028578785) 596 0.4%
 
(25.7606043802673, -80.1900149057218) 562 0.4%
 
(25.7611274810868, -80.1935450099428) 417 0.3%
 
(25.8035287900299, -80.1872679878723) 406 0.3%
 
(25.772151807327, -80.1874290228756) 390 0.3%
 
(25.7831148526855, -80.1897565441726) 376 0.2%
 
(25.7640481548699, -80.1920327865787) 358 0.2%
 
Other values (31960) 149100 96.7%
 
Max length37
Mean length35.39688029
Min length22
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Miami21Zone
Categorical

Distinct count157
Unique (%)0.1%
Missing (%)0.1%
Missing (n)184
T3-R
30287
T3-O
 
14606
T6-8-O
 
13056
Other values (153)
95984
ValueCountFrequency (%) 
T3-R 30287 19.7%
 
T3-O 14606 9.5%
 
T6-8-O 13056 8.5%
 
T5-O 10138 6.6%
 
T6-80-O 9052 5.9%
 
T6-48A-O 7883 5.1%
 
T6-48B-O 6051 3.9%
 
T6-12-O 5534 3.6%
 
T3-L 5306 3.4%
 
T6-36A-L 4178 2.7%
 
Other values (146) 47842 31.0%
 
Max length21
Mean length5.595891433
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

NewAdditionCost
Numeric

Distinct count2210
Unique (%)1.4%
Missing (%)58.7%
Missing (n)90440
Infinite (%)0.0%
Infinite (n)0
Mean158696.5371
Minimum0
Maximum333507475
Zeros (%)37.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile25000
Maximum333507475
Range333507475
Interquartile range0

Descriptive statistics

Standard deviation3809388.072
Coef of variation24.00422934
Kurtosis2427.503259
Mean158696.5371
MAD305723.7545
Skewness43.34014033
Sum1.010531939e+10
Variance1.451143748e+13
Memory size1.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 57046 37.0%
 
2000 209 0.1%
 
1000 194 0.1%
 
20000 188 0.1%
 
5000 156 0.1%
 
15000 151 0.1%
 
25000 149 0.1%
 
10000 142 0.1%
 
3000 115 0.1%
 
8000 106 0.1%
 
Other values (2199) 5221 3.4%
 
(Missing) 90440 58.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 57046 37.0%
 
1 1 < 0.1%
 
100 3 < 0.1%
 
125 3 < 0.1%
 
175 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
333507475 1 < 0.1%
 
261450644 1 < 0.1%
 
255000000 1 < 0.1%
 
201954131 1 < 0.1%
 
191782000 1 < 0.1%
 

PermitNumber
Categorical, Unique

First 5 values
BD12000007001B001
BD12000017001B001
BD12000017001E001
BD12000017001P001
BD12000025001B001
Last 5 values
BD19005622001B001
BD19005624001B001
BD19005624001P001
BD19005625001B001
BD19005625001P001

First 5 values

ValueCountFrequency (%) 
BD12000007001B001 1 < 0.1%
 
BD12000017001B001 1 < 0.1%
 
BD12000017001E001 1 < 0.1%
 
BD12000017001P001 1 < 0.1%
 
BD12000025001B001 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
BD19005625001P001 1 < 0.1%
 
BD19005625001B001 1 < 0.1%
 
BD19005624001P001 1 < 0.1%
 
BD19005624001B001 1 < 0.1%
 
BD19005622001B001 1 < 0.1%
 

PlanAcceptedDate
Categorical

Distinct count98179
Unique (%)63.7%
Missing (%)< 0.1%
Missing (n)9
06/26/2015 03:46:00 PM
 
13
10/29/2015 09:54:00 AM
 
12
09/27/2013 03:51:00 PM
 
12
Other values (98175)
154071
ValueCountFrequency (%) 
06/26/2015 03:46:00 PM 13 < 0.1%
 
10/29/2015 09:54:00 AM 12 < 0.1%
 
09/27/2013 03:51:00 PM 12 < 0.1%
 
03/03/2016 10:00:00 AM 12 < 0.1%
 
07/20/2016 08:47:00 AM 11 < 0.1%
 
06/03/2013 08:36:00 AM 10 < 0.1%
 
01/26/2016 08:26:00 AM 10 < 0.1%
 
04/03/2017 08:19:00 AM 10 < 0.1%
 
06/29/2015 02:54:00 PM 10 < 0.1%
 
09/16/2016 10:04:00 AM 10 < 0.1%
 
Other values (98168) 153998 99.9%
 
Max length22
Mean length21.99889045
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

PlanCreatedDate
Categorical

Distinct count102994
Unique (%)66.8%
Missing (%)0.0%
Missing (n)0
02/22/2016 10:47:00 AM
 
13
06/29/2015 11:45:00 AM
 
11
12/09/2016 09:08:00 AM
 
10
Other values (102991)
154083
ValueCountFrequency (%) 
02/22/2016 10:47:00 AM 13 < 0.1%
 
06/29/2015 11:45:00 AM 11 < 0.1%
 
12/09/2016 09:08:00 AM 10 < 0.1%
 
09/08/2014 01:46:00 PM 10 < 0.1%
 
10/07/2014 09:08:00 AM 10 < 0.1%
 
08/01/2013 08:37:00 AM 9 < 0.1%
 
03/17/2017 11:45:00 AM 9 < 0.1%
 
01/23/2017 12:02:00 PM 9 < 0.1%
 
04/17/2018 10:10:00 AM 9 < 0.1%
 
08/21/2013 02:16:00 PM 9 < 0.1%
 
Other values (102984) 154018 99.9%
 
Max length22
Mean length22
Min length22
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

ProcessNumber
Categorical

Distinct count109652
Unique (%)71.1%
Missing (%)0.0%
Missing (n)0
BD15014334001
 
8
BD15008622001
 
8
BD16012001001
 
8
Other values (109649)
154093
ValueCountFrequency (%) 
BD15014334001 8 < 0.1%
 
BD15008622001 8 < 0.1%
 
BD16012001001 8 < 0.1%
 
BD13017714001 8 < 0.1%
 
BD16017362001 7 < 0.1%
 
BD16002172001 7 < 0.1%
 
BD13015665001 7 < 0.1%
 
BD16001129001 7 < 0.1%
 
BD14008038001 7 < 0.1%
 
BD18001797001 7 < 0.1%
 
Other values (109642) 154043 > 99.9%
 
Max length13
Mean length13
Min length13
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

PropertyType
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Commercial
101019
Residential
53098
ValueCountFrequency (%) 
Commercial 101019 65.5%
 
Residential 53098 34.5%
 
Max length11
Mean length10.34453045
Min length10
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

RemodelingCost
Numeric

Distinct count7042
Unique (%)4.6%
Missing (%)45.8%
Missing (n)70585
Infinite (%)0.0%
Infinite (n)0
Mean28028.59274
Minimum0
Maximum34000000
Zeros (%)35.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q35000
95-th percentile75000
Maximum34000000
Range34000000
Interquartile range5000

Descriptive statistics

Standard deviation327601.0738
Coef of variation11.68810282
Kurtosis3755.260307
Mean28028.59274
MAD46238.05309
Skewness50.87572019
Sum2341284409
Variance1.073224635e+11
Memory size1.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 53872 35.0%
 
1000 1234 0.8%
 
10000 924 0.6%
 
2000 785 0.5%
 
5000 768 0.5%
 
15000 710 0.5%
 
6000 553 0.4%
 
8000 531 0.3%
 
20000 495 0.3%
 
3000 493 0.3%
 
Other values (7031) 23167 15.0%
 
(Missing) 70585 45.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 53872 35.0%
 
1 4 < 0.1%
 
45 8 < 0.1%
 
50 1 < 0.1%
 
63 9 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
34000000 1 < 0.1%
 
29227440 1 < 0.1%
 
28859360 1 < 0.1%
 
20681401 1 < 0.1%
 
17977000 1 < 0.1%
 

RemSQFT
Numeric

Distinct count2684
Unique (%)1.7%
Missing (%)2.1%
Missing (n)3197
Infinite (%)0.0%
Infinite (n)0
Mean604.4008746
Minimum0
Maximum671966
Zeros (%)79.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2350
Maximum671966
Range671966
Interquartile range0

Descriptive statistics

Standard deviation6064.000888
Coef of variation10.03307762
Kurtosis5723.204074
Mean604.4008746
MAD1023.345642
Skewness62.82331835
Sum91216180
Variance36772106.77
Memory size1.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 122019 79.2%
 
1000 807 0.5%
 
100 790 0.5%
 
200 745 0.5%
 
500 722 0.5%
 
300 567 0.4%
 
1200 500 0.3%
 
800 493 0.3%
 
2000 474 0.3%
 
1500 471 0.3%
 
Other values (2673) 23332 15.1%
 
(Missing) 3197 2.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 122019 79.2%
 
1 167 0.1%
 
2 14 < 0.1%
 
3 2 < 0.1%
 
4 16 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
671966 4 < 0.1%
 
540798 2 < 0.1%
 
435600 4 < 0.1%
 
234759 4 < 0.1%
 
200000 7 < 0.1%
 

RequiredCertificate
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)51.3%
Missing (n)79079
CC
44243
CO
30795
(Missing)
79079
ValueCountFrequency (%) 
CC 44243 28.7%
 
CO 30795 20.0%
 
(Missing) 79079 51.3%
 
Max length3
Mean length2.51311017
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

ScopeofWork
Categorical

Distinct count20
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
REMODELING/REPAIRS
67983
NEW CONSTRUCTION
28168
BUILDING ROOFING
 
9585
Other values (17)
48381
ValueCountFrequency (%) 
REMODELING/REPAIRS 67983 44.1%
 
NEW CONSTRUCTION 28168 18.3%
 
BUILDING ROOFING 9585 6.2%
 
ELECTRICAL 8038 5.2%
 
DEMOLITION 7018 4.6%
 
ADDITION AND REMODELING 5927 3.8%
 
PLUMBING 5301 3.4%
 
SIGN 5203 3.4%
 
MECHANICAL 4873 3.2%
 
40 YEAR AND OLDER RECERTIFICATION 3197 2.1%
 
Other values (10) 8824 5.7%
 
Max length33
Mean length15.69126702
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Statusdate
Categorical

Distinct count118181
Unique (%)76.7%
Missing (%)0.0%
Missing (n)0
02/12/2016 12:10:00 AM
 
172
08/24/2016 02:00:00 AM
 
76
09/05/2019 12:10:00 AM
 
67
Other values (118178)
153802
ValueCountFrequency (%) 
02/12/2016 12:10:00 AM 172 0.1%
 
08/24/2016 02:00:00 AM 76 < 0.1%
 
09/05/2019 12:10:00 AM 67 < 0.1%
 
08/29/2016 02:00:00 AM 63 < 0.1%
 
11/08/2016 02:00:00 AM 54 < 0.1%
 
06/25/2017 02:00:00 AM 53 < 0.1%
 
08/31/2016 02:00:00 AM 51 < 0.1%
 
09/14/2018 12:10:00 AM 43 < 0.1%
 
09/24/2019 12:10:00 AM 42 < 0.1%
 
09/23/2019 12:10:00 AM 38 < 0.1%
 
Other values (118171) 153458 99.6%
 
Max length22
Mean length22
Min length22
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

TotalCost
Highly correlated

This variable is highly correlated with NewAdditionCost and should be ignored for analysis

Correlation0.9322690698

TotalDaysInPlanReview
Categorical

Distinct count74681
Unique (%)48.5%
Missing (%)< 0.1%
Missing (n)61
0 Day(s) 0 Hour(s) 19 Minute(s)
 
270
0 Day(s) 0 Hour(s) 23 Minute(s)
 
267
0 Day(s) 0 Hour(s) 18 Minute(s)
 
267
Other values (74677)
153252
ValueCountFrequency (%) 
0 Day(s) 0 Hour(s) 19 Minute(s) 270 0.2%
 
0 Day(s) 0 Hour(s) 23 Minute(s) 267 0.2%
 
0 Day(s) 0 Hour(s) 18 Minute(s) 267 0.2%
 
0 Day(s) 0 Hour(s) 20 Minute(s) 257 0.2%
 
0 Day(s) 0 Hour(s) 14 Minute(s) 251 0.2%
 
0 Day(s) 0 Hour(s) 37 Minute(s) 249 0.2%
 
0 Day(s) 0 Hour(s) 13 Minute(s) 247 0.2%
 
0 Day(s) 0 Hour(s) 30 Minute(s) 245 0.2%
 
0 Day(s) 0 Hour(s) 25 Minute(s) 245 0.2%
 
0 Day(s) 0 Hour(s) 15 Minute(s) 244 0.2%
 
Other values (74670) 151514 98.3%
 
Max length35
Mean length31.91105459
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

TotalDaysInPlanReviewNumeric
Numeric

Distinct count1526
Unique (%)1.0%
Missing (%)< 0.1%
Missing (n)61
Infinite (%)0.0%
Infinite (n)0
Mean86.82916602
Minimum0
Maximum2531
Zeros (%)24.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median16
Q385
95-th percentile424
Maximum2531
Range2531
Interquartile range84

Descriptive statistics

Standard deviation179.1941576
Coef of variation2.06375537
Kurtosis23.89640406
Mean86.82916602
MAD105.9271764
Skewness4.127417511
Sum13376554
Variance32110.54613
Memory size1.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 37133 24.1%
 
1 6546 4.2%
 
2 3634 2.4%
 
5 3141 2.0%
 
6 3137 2.0%
 
7 3087 2.0%
 
3 3019 2.0%
 
4 2878 1.9%
 
14 2039 1.3%
 
8 1983 1.3%
 
Other values (1515) 87459 56.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 37133 24.1%
 
1 6546 4.2%
 
2 3634 2.4%
 
3 3019 2.0%
 
4 2878 1.9%
 

Maximum 5 values

ValueCountFrequency (%) 
2531 1 < 0.1%
 
2479 1 < 0.1%
 
2461 1 < 0.1%
 
2298 1 < 0.1%
 
2294 1 < 0.1%
 

TotalSQFT
Highly correlated

This variable is highly correlated with AdditionSQFT and should be ignored for analysis

Correlation0.9908311729

WorkItems
Categorical

Distinct count14730
Unique (%)9.6%
Missing (%)< 0.1%
Missing (n)20
WINDOWS / DOORS / SKYLIGHT
 
4915
WOOD/LAMINATE/TILE
 
4284
REPLACE SAME LOCATION CENTRAL AC / HEATING SYSTEM
 
3896
Other values (14726)
141002
ValueCountFrequency (%) 
WINDOWS / DOORS / SKYLIGHT 4915 3.2%
 
WOOD/LAMINATE/TILE 4284 2.8%
 
REPLACE SAME LOCATION CENTRAL AC / HEATING SYSTEM 3896 2.5%
 
TEMPORARY FOR TESTING 3481 2.3%
 
FLAT ROOF 3467 2.2%
 
ELECTRICAL FOR FIRE ALARM 3370 2.2%
 
40 YEAR AND OLDER RECERTIFICATION 3197 2.1%
 
SERVICE REPAIR 3011 2.0%
 
EXISTING FIRE ALARM SYSTEM 2814 1.8%
 
SHINGLE ROOF 2813 1.8%
 
Other values (14719) 118849 77.1%
 
Max length1478
Mean length58.76763757
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

AdditionSQFTApplicationNumberBuildingFinalLastInspDateBuildingFinalLastInspResultBuildingPermitStatusDescriptionBuildingPermitStatusReasonDescriptionCertificatecodeCertificatedateCompanyAddressCompanyCityCompanyNameCompanyZipDaysInCityDaysInCityNumericDeliveryAddressFirstSubmissionDateFolioNumberIsPermitFinalIsPrivateProviderIssuedDateLocation_1Miami21ZoneNewAdditionCostPermitNumberPlanAcceptedDatePlanCreatedDateProcessNumberPropertyTypeRemodelingCostRemSQFTRequiredCertificateScopeofWorkStatusdateTotalCostTotalDaysInPlanReviewTotalDaysInPlanReviewNumericTotalSQFTWorkItems
00.0BD13022970NaNNaNFinalAll Inspections are finalized.NaNNaN17225 S. Dixie HwyMiamiIsaacs Roofing33157.00 Day(s) 4 Hour(s) 35 Minute(s)0.0159 NW 9 ST10/05/2015 10:19:00 AM101020501060YESTrue10/26/2015 10:45:00 AM(25.7827783915511, -80.1976130743953)T6-24A-O0.0BD13022970014BR00110/05/2015 10:19:00 AM10/02/2015 12:52:00 PMBD13022970014Commercial0.00.0CONEW CONSTRUCTION05/09/2016 10:44:00 AM77000.021 Day(s) 0 Hour(s) 26 Minute(s)21.00.0METAL ROOF|FLAT ROOF
1780.0BD1301154206/29/2018 09:56:00 AMNaNFinalAll Inspections are finalized.CO06/29/2018 09:56:00 AM9800 SW 92 AVMIAMIAMCON GROUP INC33176.0178 Day(s) 14 Hour(s) 42 Minute(s)178.03380 CRYSTAL CT01/09/2013 02:58:00 PM141150200160YESFalse08/19/2013 11:22:00 AM(25.7392170589991, -80.2239576056458)T3-R65000.0BD13011542001B00101/09/2013 02:57:00 PM01/08/2013 11:19:00 AMBD13011542001Residential15000.0100.0COADDITION AND REMODELING06/29/2018 09:56:00 AM80000.0221 Day(s) 20 Hour(s) 25 Minute(s)221.0880.0SINGLE FAMILY RESIDENCE
20.0BD13015901NaNNaNFinalAll Inspections are finalized.NaNNaN10400 W .SR 84 BAY 112DAVIECAILIS MECHANICAL CORP.33324.00 Day(s) 0 Hour(s) 13 Minute(s)0.01300 BRICKELL BAY DR03/05/2014 11:36:00 AM141391250001YESTrue03/11/2014 09:15:00 AM(25.7605625176232, -80.1900200492368)T6-48A-ONaNBD13015901027MA00103/05/2014 11:35:00 AM02/26/2014 11:30:00 AMBD13015901027CommercialNaN0.0CONEW CONSTRUCTION09/19/2014 12:06:00 PM1000.05 Day(s) 21 Hour(s) 40 Minute(s)5.00.0VENTING SYSTEM
30.0BD15008841NaNNaNFinalAll Inspections are finalized.NaNNaN11565 SW 7 STMIAMIESPIRITU SANTO DEVELOPMENT & CONSTRUCTION GROU...33174.00 Day(s) 0 Hour(s) 55 Minute(s)0.03517 CRYSTAL VIEW CT06/26/2015 09:43:00 AM141150250040YESFalse06/26/2015 11:56:00 AM(25.7374142240009, -80.2246739487278)T3-RNaNBD15008841001BR00106/26/2015 09:43:00 AM06/25/2015 09:19:00 PMBD15008841001ResidentialNaN0.0NaNBUILDING ROOFING07/14/2015 09:44:00 AM19500.00 Day(s) 2 Hour(s) 13 Minute(s)0.00.0FLAT ROOF|METAL ROOF
40.0BD14002550NaNNaNFinalAll Inspections are finalized.NaNNaN1461 NW 23 STMiamiT & S Roofing Systems Inc33142.00 Day(s) 0 Hour(s) 30 Minute(s)0.04880 NW 5 ST03/07/2014 08:19:00 AM141060780070YESFalse03/07/2014 10:00:00 AM(25.7770086304017, -80.2757351816447)T3-ONaNBD14002550001BR00103/07/2014 08:19:00 AM03/07/2014 08:07:00 AMBD14002550001ResidentialNaN0.0NaNBUILDING ROOFING04/24/2014 03:37:00 PM12000.00 Day(s) 1 Hour(s) 41 Minute(s)0.00.0METAL ROOF
50.0BD1401020909/06/2016 04:04:00 PMNaNFinalAll Inspections are finalized.CC09/06/2016 04:04:00 PM1616-102 CAPE CORAL PKWYCAPE CORALREYES INC33914.0142 Day(s) 14 Hour(s) 1 Minute(s)142.01909 SW 27 AV09/10/2014 11:07:00 AM141100230110YESFalse02/20/2015 09:59:00 AM(25.7537150298413, -80.238230053775)T6-8-O0.0BD14010209001B00109/10/2014 11:07:00 AM09/10/2014 09:53:00 AMBD14010209001Commercial50000.0800.0CCREMODELING/REPAIRS09/06/2016 04:04:00 PM50000.0162 Day(s) 22 Hour(s) 52 Minute(s)162.0800.0MEDICAL OR DENTAL OFFICE
60.0BD16008841NaNNaNFinalAll Inspections are finalized.NaNNaN301 FLAGLER DRMIAMIDOUGLAS ORR PLUMBING INC33012.01 Day(s) 0 Hour(s) 53 Minute(s)1.02470 NW 38 ST06/22/2016 11:20:00 AM131220380020YESFalse06/23/2016 01:41:00 PM(25.8109512528316, -80.2374171063099)D1NaNBD16008841001P00106/22/2016 11:19:00 AM06/22/2016 10:36:00 AMBD16008841001CommercialNaN0.0NaNPLUMBING07/06/2016 09:38:00 AM8900.01 Day(s) 2 Hour(s) 22 Minute(s)1.00.0STORM SEWER
70.0BD1301516010/30/2014 09:50:00 AMNaNFinalAll Inspections are finalized.CC10/31/2014 03:06:00 PM4710 NW 37 AvenueMiamiToledo Doors Inc. dba Toledo Iron Works33142.00 Day(s) 9 Hour(s) 19 Minute(s)0.01925 BRICKELL AV # 5DPH04/08/2013 10:01:00 AM141390314370YESFalse05/21/2013 10:22:00 AM(25.7537938222174, -80.1982958458641)T6-24-R0.0BD13015160001B00104/08/2013 10:00:00 AM04/08/2013 09:48:00 AMBD13015160001Commercial32000.00.0NaNREMODELING/REPAIRS10/30/2014 09:50:00 AM32000.043 Day(s) 0 Hour(s) 22 Minute(s)43.00.0INTERIOR RAILINGS:METAL/GLASS/WOOD/CONCRETE|EX...
80.0BD1600456607/05/2016 09:05:00 AMNaNFinalAll Inspections are finalized.NaNNaN17661 NW 82 CTMIAMIBY HIS GRACE CONSTRUCTION SERVICES INC33015.00 Day(s) 1 Hour(s) 28 Minute(s)0.065 NW 26 ST04/25/2016 08:47:00 AM131250290150YESFalse05/12/2016 03:55:00 PM(25.801601167324, -80.1963579287021)T5-LNaNBD16004566001B00104/25/2016 08:47:00 AM04/07/2016 04:00:00 PMBD16004566001ResidentialNaN0.0NaNDEMOLITION07/05/2016 09:05:00 AM8399.017 Day(s) 7 Hour(s) 8 Minute(s)17.00.0DEMOLITION - TOTAL
90.0BD1600930309/26/2016 10:42:00 AMNaNFinalAll Inspections are finalized.CC11/16/2016 07:38:00 AM18630 NE 18 Ave #234MiamiGreat Walls of America Inc33179.00 Day(s) 3 Hour(s) 36 Minute(s)0.0555 NE 15 ST # 11-E07/01/2016 09:15:00 AM132310521680YESFalse07/07/2016 12:01:00 PM(25.7897947573702, -80.1856839336501)T6-36B-ONaNBD16009303001B00107/01/2016 09:15:00 AM07/01/2016 08:36:00 AMBD16009303001Commercial14500.00.0CCREMODELING/REPAIRS09/26/2016 10:42:00 AM14500.06 Day(s) 2 Hour(s) 46 Minute(s)6.00.0KITCHEN REMODELING/BATHROOM REMODELING/LAUNDRY...

Last rows

AdditionSQFTApplicationNumberBuildingFinalLastInspDateBuildingFinalLastInspResultBuildingPermitStatusDescriptionBuildingPermitStatusReasonDescriptionCertificatecodeCertificatedateCompanyAddressCompanyCityCompanyNameCompanyZipDaysInCityDaysInCityNumericDeliveryAddressFirstSubmissionDateFolioNumberIsPermitFinalIsPrivateProviderIssuedDateLocation_1Miami21ZoneNewAdditionCostPermitNumberPlanAcceptedDatePlanCreatedDateProcessNumberPropertyTypeRemodelingCostRemSQFTRequiredCertificateScopeofWorkStatusdateTotalCostTotalDaysInPlanReviewTotalDaysInPlanReviewNumericTotalSQFTWorkItems
1541070.0BD17017975NaNNaNActivePermit is Active. Ready for Inspections.NaNNaN5101 COLLINS AVMIAMI BEACHREBUILD MIAMI LLC33140.00 Day(s) 6 Hour(s) 34 Minute(s)0.01129 NW 28 ST12/11/2017 10:30:00 AM131260361740NOFalse06/04/2018 03:37:00 PM(25.8025244658363, -80.2139244460857)T3-ONaNBD17017975001B00112/11/2017 10:30:00 AM12/11/2017 09:42:00 AMBD17017975001Residential7000.00.0NaNREMODELING/REPAIRS07/26/2019 10:43:00 AM7000.0175 Day(s) 5 Hour(s) 7 Minute(s)175.00.0CBS FENCE
1541080.0BD1801114907/25/2019 09:20:00 AMNaNFinalAll Inspections are finalized.CC07/26/2019 08:47:00 AM31 SE 5 STREET # 2908MiamiRubio Construction Consultants33131.075 Day(s) 11 Hour(s) 0 Minute(s)75.0200 SE 1 ST 60108/24/2018 08:52:00 AM101120002040YESTrue01/07/2019 01:01:00 PM(25.77332504, -80.18994634)T6-80-ONaNBD18011149001B00108/23/2018 08:50:00 AM07/17/2018 09:09:00 AMBD18011149001Commercial314650.03596.0CCREMODELING/REPAIRS07/25/2019 09:20:00 AM314650.0137 Day(s) 4 Hour(s) 11 Minute(s)137.03596.0PROFESSIONAL OFFICE / BANK / FINANCIAL INSTITU...
1541090.0BD17001452NaNNaNActivePermit is Active. Ready for Inspections.NaNNaN3715 NORTHSIDE PKWY NW BLDG 300 - SUITE 30327ATLANTAJUNEAU CONSTRUCTION33324.09 Day(s) 8 Hour(s) 37 Minute(s)9.03015 GRAND AV06/20/2018 09:43:00 AM141211260010NOTrue07/31/2018 03:53:00 PM(25.7282207815248, -80.2419336841946)T5-ONaNBD17001452003B00106/20/2018 09:43:00 AM06/12/2018 03:22:00 PMBD17001452003CommercialNaN0.0CCREMODELING/REPAIRS07/26/2019 09:49:00 AM17354.041 Day(s) 6 Hour(s) 10 Minute(s)41.00.0REGULAR EXTERIOR:DOORS
1541100.0BD17016666NaNNaNActivePermit is Active. Ready for Inspections.NaNNaN2200 D DIXIE HWYHollywoodBengoa Construction Inc.33139.0213 Day(s) 0 Hour(s) 15 Minute(s)213.01925 BRICKELL AV11/14/2017 09:46:00 AM141390310001NOFalse09/24/2018 11:12:00 AM(25.7537938222174, -80.1982958458641)T6-24A-RNaNBD17016666001B00111/14/2017 09:45:00 AM11/14/2017 09:05:00 AMBD17016666001Commercial2300000.00.0NaNREMODELING/REPAIRS09/24/2018 11:12:00 AM2300000.0314 Day(s) 1 Hour(s) 27 Minute(s)314.00.0WOOD OR METAL DECK/CONCRETE SLAB|EXTERIOR RAIL...
1541110.0BD17012936NaNNaNActivePermit is Active. Ready for Inspections.NaNNaN8181 NW 36 ST #31MIAMIFLORIDA LEMARK CORP33166.01258 Day(s) 21 Hour(s) 32 Minute(s)1258.0401 BISCAYNE BLVD09/25/2017 11:07:00 AM101000000522NOFalse07/26/2019 03:59:00 PM(25.7789472940884, -80.1867494973167)T6-8-ONaNBD17012936001B00109/25/2017 11:06:00 AM08/28/2017 12:08:00 PMBD17012936001CommercialNaN0.0NaNPHASED PERMIT07/26/2019 03:59:00 PM100.0669 Day(s) 4 Hour(s) 53 Minute(s)669.00.0PHASE CLASS II: FOUNDATION ONLY
1541120.0BD19005137NaNNaNFinalAll Inspections are finalized.NaNNaN2530 SW 153RD PASSMIAMIELECTRICFIRE CORP33185.0NaNNaN717 NE 27 STNaN132300190180YESFalse04/22/2019 01:50:00 PM(25.80298868, -80.18573575)T6-36A-L0.0BD19005137001F00103/27/2019 10:08:00 AM03/21/2019 09:17:00 AMBD19005137001Commercial0.00.0NaNFIRE07/26/2019 09:19:00 AM8000.026 Day(s) 3 Hour(s) 42 Minute(s)26.00.0EXISTING FIRE ALARM SYSTEM
1541130.0BD13011378NaNNaNActivePermit is Active. Ready for Inspections.NaNNaN350 BUSINESS PARKWAY SUITE 104ROYAL PALM BEACHAG SERVICES MAINTENANCE & REPAIR INC33411.056 Day(s) 3 Hour(s) 25 Minute(s)56.02153 SW 22 ST 60101/03/2013 10:25:00 AM141100530030NOFalse03/28/2013 10:21:00 AM(25.7507822844358, -80.2291934525465)T5-O0.0BD13011378001MA00101/03/2013 10:25:00 AM01/03/2013 10:15:00 AMBD13011378001Commercial0.01200.0CCREMODELING/REPAIRS07/26/2019 11:14:00 AM10000.083 Day(s) 23 Hour(s) 56 Minute(s)83.01200.0NEW CENTRAL AC / HEATING SYSTEM|SHEET METAL WORK
1541140.0BD17018324NaNNaNFinalAll Inspections are finalized.NaNNaN8900 sw 126 terrMiamiAlpero General Contractor Inc.33127.010 Day(s) 0 Hour(s) 36 Minute(s)10.02953 SHIPPING AV02/01/2019 11:09:00 AM141210170070YESFalse02/19/2019 12:38:00 PM(25.7337208815229, -80.2407565067646)T3-ONaNBD17018324004BR00102/01/2019 11:06:00 AM01/18/2019 08:07:00 PMBD17018324004ResidentialNaN0.0CONEW CONSTRUCTION07/26/2019 11:21:00 AM15000.018 Day(s) 1 Hour(s) 32 Minute(s)18.00.0FLAT ROOF
1541150.0BD19003668NaNNaNActivePermit is Active. Ready for Inspections.NaNNaN1600 nw 28th aveMiamiCPS Electric Inc.33125.0NaNNaN3131 NE 7 AV # 3201NaN132300950270NOFalse07/26/2019 12:53:00 PM(25.80729208, -80.18590346)T6-36A-L0.0BD19003668001E00103/11/2019 06:37:00 AM03/01/2019 09:37:00 AMBD19003668001Commercial0.02327.0NaNREMODELING/REPAIRS07/26/2019 12:53:00 PM3000.0137 Day(s) 6 Hour(s) 16 Minute(s)137.02327.0FIXTURE HEADS|ROUGH WIRING OUTLETS
154116301.0BD16010527NaNNaNActivePermit is Active. Ready for Inspections.NaNNaN15700 NE 2nd AvenueMiamiRegosa Engineering Services33162.0350 Day(s) 12 Hour(s) 20 Minute(s)350.05601 NE 5 AV09/09/2016 09:46:00 AM132180370350NOFalse07/26/2019 03:02:00 PM(25.8279324875411, -80.1846579277803)T3-R0.0BD16010527001P00109/09/2016 08:37:00 AM07/27/2016 12:18:00 PMBD16010527001Residential0.0200.0COADDITION AND REMODELING07/26/2019 03:02:00 PM25000.01050 Day(s) 6 Hour(s) 25 Minute(s)1050.0501.0ROUGHING FIXTURE: BATHTUB|SETTING FIXTURE: BAT...